Job Overview
We are looking for an accomplished and driven Database Management Specialist to join our dedicated team and provide essential support to a key client in Business Solutions Development (BSD). This position calls for seasoned professionals proficient in solution architecture, data management, ETL programming, and data analytics, with a focus on modernizing and enhancing our data management and analytics capabilities.
Key Responsibilities
- Evaluate existing data warehouse operations and make recommendations for improvements, while overseeing modernization initiatives.
- Create architectural diagrams, perform data and performance assessments, and generate technical documentation outlining current and future data warehouse states.
- Assist in developing technical prototypes and proofs-of-concept to assess potential technologies for data warehouse advancements.
- Offer engineering support for data warehouse systems, networks, cloud infrastructure, security, and applications, addressing technical challenges as they emerge.
- Revamp data management workflows to align them more effectively with our organizational mission.
- Design comprehensive database schemas and enhance data organization and retrieval in SQL Server.
- Employ SQL Server Integration Services (SSIS) for complex ETL tasks to ensure precise data transformation and loading.
- Implement advanced query optimization strategies within SQL Server to boost performance and speed up data retrieval.
- Expertly oversee SQL Server environments to guarantee high availability and efficient resource scaling.
- Prepare data for anomaly detection and machine learning algorithms utilizing SQL Server’s analytical features.
- Leverage various database systems, including data warehouses and data marts, to facilitate business, financial, and operational analyses and reporting.
- Conduct data analyses to elevate information management systems and services.
- Stay abreast of various data technologies (e.g., Oracle, SQL Data Warehouse, SQL Server) and demonstrate a willingness to learn how to utilize these tools to enhance business intelligence.
- Develop reports, dashboards, and visual analytics using both existing and emerging technologies and tools.
- Share insights and recommendations regarding new technologies with team members.
- Foster a collaborative, team-oriented environment while engaging creatively in problem-solving.
- Exhibit exceptional communication and interpersonal skills.
- Experience in a client-focused environment is advantageous.
Required Skills
- Strong proficiency in solution architecture and data management.
- Experience with ETL programming and data analytics.
- Solid knowledge of SQL Server and related technologies.
- Familiarity with cloud technologies and large-scale systems.
- Excellent communication and interpersonal skills.
- Ability to thrive in a client-focused environment.
Qualifications
- A Master's degree with a minimum of 4 years of specialized experience, or a Bachelor's degree with at least 6 years of relevant experience in technology.
- Demonstrated expertise in complex networks, cloud technologies, and cross-platform integration, along with large-scale systems design and implementation.
Career Growth Opportunities
This role presents a unique opportunity for professionals looking to advance their careers in data management and analytics. We encourage ongoing professional development and the exploration of new technologies that can enhance your skill set and career trajectory.
Company Culture And Values
We pride ourselves on fostering a collaborative and inclusive work environment where diversity is celebrated. Our commitment to open communication and teamwork allows for a supportive workplace where creativity and problem-solving thrive.
Compensation And Benefits
We offer a comprehensive benefits package, which includes:
- Paid Time Off and Paid Holidays
- Company-paid Life/AD&D Insurance
- Company-paid Short-Term and Long-Term Disability
- Health Insurance with Company Contribution
- 401(k) Plan with Company Match
- Opportunities for Employee Referral Bonuses and Performance Bonuses
- And many more!
Employment Type: Full-Time